SQL

Description

SQL executes one or more SQL statements against a connected database within a process. Use this process entry for database administration tasks — for example, running DDL statements to create or alter tables, executing stored procedures, truncating staging tables before a workflow runs, or performing setup operations that need to happen between workflow executions. Multiple statements can be included in a single entry, separated by semicolons.

The SQL process entry is flexible; you can perform procedure calls, create and analyze tables, and more. Common uses associated with the SQL process entry include truncating tables, drop index, partition loading, refreshing materialized views, disabling co nstraints, disabling statistics, and so on.

Configurations

Field Name	Description
Process Entry name	Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name.
Database Connection	The database connection to use.
SQL from file	Enable this option to load the SQL statement from a file given by the SQL filename
SQL filename	The filename for the file with SQL statements.
Send SQL as single statement?	Enable this option to not separate the statement by semicolons. This is often useful when a script is given or multiple statements should be processed and committed as one single statement.
Use variable substitution?	Enables variables to be used in the SQL Script.
SQL script	The SQL script to execute. Multiple statements can be separated by semicolons.